Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_AUDIT_POLICIES

`ALL_AUDIT_POLICIES` describes the fine-grained auditing policies on the tables and views accessible to the current user.

Related Views

- `DBA_AUDIT_POLICIES` describes all fine-grained auditing policies in the database.

- `USER_AUDIT_POLICIES` describes the fine-grained auditing policies on the tables and views owned by the current user. This view does not display the `OBJECT_SCHEMA` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OBJECT_SCHEMA` | `VARCHAR2(30)` | `NOT NULL` | Owner of the table or view
`OBJECT_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the table or view
`POLICY_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the policy
`POLICY_TEXT` | `VARCHAR2(4000)` |  | Audit condition
`POLICY_COLUMN` | `VARCHAR2(30)` |  | Relevant column
`PF_SCHEMA` | `VARCHAR2(30)` |  | Owner of the audit handler function
`PF_PACKAGE` | `VARCHAR2(30)` |  | Name of the package containing the audit handler function
`PF_FUNCTION` | `VARCHAR2(30)` |  | Name of the audit handler function
`ENABLED` | `VARCHAR2(3)` |  | Indicates whether the policy is enabled (`YES`) or disabled (`NO`)
`SEL` | `VARCHAR2(3)` |  | Indicates whether the policy is applied to queries on the object (`YES`) or not (`NO`)
`INS` | `VARCHAR2(3)` |  | Indicates whether the policy is applied to `INSERT` statements on the object (`YES`) or not (`NO`)
`UPD` | `VARCHAR2(3)` |  | Indicates whether the policy is applied to `UPDATE` statements on the object (`YES`) or not (`NO`)
`DEL` | `VARCHAR2(3)` |  | Indicates whether the policy is applied to `DELETE` statements on the object (`YES`) or not (`NO`)
`AUDIT_TRAIL` | `VARCHAR2(11)` |  | Indicates whether the `SQL_TEXT` and `SQL_BIND` columns in the fine-grained audit trail are populated for this policy (`DB_EXTENDED`) or not (`DB`)
`POLICY_COLUMN_OPTION` | `VARCHAR2(11)` |  | Indicates whether all columns in the `AUDIT_COLUMN` parameter (`ALL_COLUMNS`) or any of the columns in the `AUDIT_COLUMN` parameter (`ANY_COLUMNS`) are considered for triggering fine-grained auditing

See Also: "DBA_AUDIT_POLICIES" "USER_AUDIT_POLICIES"